Performance Analysis of Distributed Database Recovery Protocols
نویسنده
چکیده
An early recovery protocol that was investigated at length and is currently implemented in most commercial Distributed Database Management System products is the two-phase commit protocol. However, there is one main drawback in using this, namely blocking, that is, operational sites having to wait for the recovery of a failed site in order to complete a transaction. The two-phase commit protocol continues to be implemented in commercial Distributed Database Management System products even though alternatives to it have been developed to alleviate the blocking drawback. The alternatives are the three-phase commit protocol and a vendor developed replication technology. A critical and systematic analysis of these recovery protocols was conducted to determine the justification for continuing to implement the two-phase commit protocol in current commercial Distributed Database Management System products. This paper will present the results of the critical analysis.
منابع مشابه
Recovery and Performance of Atomic Commit Processing in Distributed Database Systems
A transaction is traditionally deened so as to provide the properties of atomicity, consistency, integrity, and durability (ACID) for any operation it performs. In order to ensure the atomicity of distributed transactions, an atomic commitprotocol needs to be followed by all sites participating in a transaction execution to agree on the nal outcome, that is, commit or abort. A variety of commit...
متن کاملCommit processing in distributed real-time database systems
Incorporating distributed data into the real-time framework incurs the well-known additional complexities that are associated with transaction concurrency control and database recovery in distributed database systems. We investigate here the performance implications of supporting transaction atomicity in a distributed real-time database system. Using a detailed simulation model of a rm-deadline...
متن کاملA Fast and Robust Failure Recovery Scheme for Shared - NothingGigabit - Networked Databases
In the future, wide area gigabit networks will interconnect database servers around the globe creating extremely powerful distributed information systems. In a high speed network, the size of the message is less of a concern than the number of sequential phases of message passing. In a previous paper, we have developed a lock-based concurrency control protocol for gigabit-networked databases (G...
متن کاملRecovery Concepts for Data Sharing Systems
Data sharing refers to a general distributed architecture for high performance transaction processing. The nodes of a data sharing system are locally coupled via a high-speed interconnect and can directly access all disks and thus the entire database. While concurrency and coherence control protocols for data sharing have been discussed in previous work, the important area of recovery has mostl...
متن کاملFault Tolerance in Decentralized Systems
In a decentralised system the problems of fault tolerance, and in particular error recovery, vary greatly depending on the design assumptions. For example, in a distributed database system, if one disregards the possibility of undetected invalid inputs or outputs, the errors that have to be recovered from will just affect the database, and backward error recovery will be feasible and should suf...
متن کامل